Computer science Lesson Plan
Class: 5 - Lesson:6.1 Introduction of spreadsheet,Basic operations

Purpose:Students should learn basic operations like addition,subtraction,multiplication and division in spreadsheet.

No. of Classes

One class (Teacher's decision).

Material Required

Open office (Spreadsheet)

Curriculum Content
  • 4) Other applications of computers.
    •

    Prior knowledge

    Students should know about Editing operations of cells,properties of cells.

    Exercise

    Exercise:1


    1.Adding, subtracting, multiplying and dividing using spreadsheet operators.

    Solutions


  • Link to view the solution for exercise-1.

    • Teacher's Instruction
    1. Teachers should explain the importance of formulas in spreadsheets.
    2. Teachers should also explain about the autofill feature (drag the autofill handle at the bottom right of a cell) and how this is useful in filling dates, days, or S.No).
    3. Teachers should explain that the numbers at the left most column indicate row numbers and the alphabets at the top most row indicate columns in spreadsheet.
    4. The students should know & the usage of the formula bar that is placed at the top left of the sheet.
    5. Show what errors we get when we do formulas either with empty cells or with invalid types. i.e. adding a non-number.
    6. Teachers should ensure that students practice all these features.